package com.example.personnel_oa.mapper;
//数据访问层
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.comment_oa.pojos.Dimission;
import com.example.comment_oa.pojos.SysEmployee;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import java.util.List;

/**
* @author HUAWEI
* @description 针对表【dimission】的数据库操作Mapper
* @createDate 2022-10-19 16:39:55
* @Entity personnel_oa.pojos.Dimission
*/
@Mapper//识别他为mybatis的mapper接口
public interface DimissionMapper extends BaseMapper<Dimission> {
    @Select("SELECT * FROM dimission")//利用注解开发就不需要xml映射文件
    public List<Dimission> Methods_dim();

    public List<SysEmployee> allDimission();

    public List<Dimission> allrelieve(int dimId);
    //新增离职申请数据
    int shenqinglizhi(Dimission dimission);
    //签订合同后修改状态
    int state(int dimId);
    //根据编号查询离职审批数据详情
    Dimission dimBiaanhao(String dimBianhao);
    //离职审批成功
    int dimState(String dimName,String dimBianhao);
    //离职审批失败
    int dimStates(String dimName,String dimBianhao);
}




